UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8NKMnE7OLTs47P8ntPg8qVG0WLns2LI32ZPili6KpTo='
WHERE
key_id = 'bf037974cd052978b8a843d76852417742155c305e5db89d89e3df527e30e55c'
AND (
token = '8NKMnE7OLTs47P8ntPg8qVG0WLns2LI32ZPili6KpTo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)