UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bJ1wS82yV8+uXHTHhtVdUh99fS5x7NIUvrFH/bmff9I='
WHERE
key_id = 'e2b0e25ed68dbe4a81e0690ed0706d162e6fc1924ec372689edc29f6ecffffae'
AND (
token = 'bJ1wS82yV8+uXHTHhtVdUh99fS5x7NIUvrFH/bmff9I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)