UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8xadCIQALvp9bum63xaC6ISmxDSj2HnpgDsJSIc+7bc='
WHERE
key_id = '7a9fe0364766e7a935cb1201ef7a1008035aadff4855dd810bc412d6fde96ef6'
AND (
token = '8xadCIQALvp9bum63xaC6ISmxDSj2HnpgDsJSIc+7bc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)