UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U6Xy1u0qQjTLwEiIFoxG50wZaoPSvTvjEsfzG9LlZ94='
WHERE
key_id = '4c3d217fc9401446e8ee548a331e782e4a26a1f3bf1952d19727e61b239c7279'
AND (
token = 'U6Xy1u0qQjTLwEiIFoxG50wZaoPSvTvjEsfzG9LlZ94='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)