UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jR/zkcPSxYsKNTmYFysoVa/g7CAFp11zty17A5zamAA='
WHERE
key_id = 'a4d6e21f88ace007d54356f3b180204b94cc9a7642cb39c85696244d810c9ef4'
AND (
token = 'jR/zkcPSxYsKNTmYFysoVa/g7CAFp11zty17A5zamAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)