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