UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pNnEMSslORr8GiebccOwBpzs/RAYm7aKdTUyazRY/ss='
WHERE
key_id = 'a49b58ac370092fb67578a4f4a68c207cc38d03c7851320a86f2926f63709b47'
AND (
token = 'pNnEMSslORr8GiebccOwBpzs/RAYm7aKdTUyazRY/ss='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)