UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HzW1BB5iHLqtlYOg0aSHNkWld3np73lerfjgWhgfeWQ='
WHERE
key_id = '1cc990ec09d88703b66bb5ed887405c16ae1ce2dbfe3f789da57ed24395a4700'
AND (
token = 'HzW1BB5iHLqtlYOg0aSHNkWld3np73lerfjgWhgfeWQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)