UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Is7z0oSHm3LG0Byb2AIYxYuzrUxzB7BoBzUBiS341g='
WHERE
key_id = 'd6ad3c0a7a444c3b11038a67a0d38d55424e11a5acb1b083b2916f848e80a8c3'
AND (
token = '3Is7z0oSHm3LG0Byb2AIYxYuzrUxzB7BoBzUBiS341g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)