UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hcTSXcL7iLgwDj+hn2t99JdqgSiZuVvxHUueqslbNa8='
WHERE
key_id = 'e59233731a17f510f93bcb995d036fc61abd05bd5dab388d81a1fd9d45250b33'
AND (
token = 'hcTSXcL7iLgwDj+hn2t99JdqgSiZuVvxHUueqslbNa8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)