UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/zXi+ylYxV4TaY9nOWHCG0MNjSDuEHdCTPA5zhKf6Oo='
WHERE
key_id = '1de82f9b480557ae1be91125c96221baead72929329205944b55e14f8aeb79b4'
AND (
token = '/zXi+ylYxV4TaY9nOWHCG0MNjSDuEHdCTPA5zhKf6Oo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)