UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tcmxGhem+UDCvVyRTZgKCRNQh6AuoCcT7YA2wWmgmNE='
WHERE
key_id = 'e7c5e0afec5ef9511856d15134a77970609abcfc8ec722587fcaaba68cd63742'
AND (
token = 'tcmxGhem+UDCvVyRTZgKCRNQh6AuoCcT7YA2wWmgmNE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)