UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZRvhWhGmg5PsVuSYUYRVBR7ekXBoQtnVhllIBt2EnY8='
WHERE
key_id = 'e8fa3b2202512fa9887db0613b68455a71434ce3ad15e44f1007429e7ee0f00a'
AND (
token = 'ZRvhWhGmg5PsVuSYUYRVBR7ekXBoQtnVhllIBt2EnY8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)