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