UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6HX5B9qGZfyHvuu4pKnsM++n+GobAGF41LRBm0vVTP0='
WHERE
key_id = 'e6222b6f3c7520642be162634b78780194817d1a1bc5ce0ce1b52b9d3e66b552'
AND (
token = '6HX5B9qGZfyHvuu4pKnsM++n+GobAGF41LRBm0vVTP0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)