UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E7NgCi6V8oZMyjtEKwpMEDCshBNQmX7CJjM+c28c3L4='
WHERE
key_id = '22fb39c4c6ac26ccd3123ba4f3787f6b31d6a42dc78b5d798bef538d93b9fc29'
AND (
token = 'E7NgCi6V8oZMyjtEKwpMEDCshBNQmX7CJjM+c28c3L4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)