UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'auNae0OJvHbJX+NERz4POXOuqsQQsm4X25Guseq+80g='
WHERE
key_id = 'c7eaa9237c6bc2429bf991b7a2c9c8d54dfd8e0ce48ebf7829db2fd9cf0bad68'
AND (
token = 'auNae0OJvHbJX+NERz4POXOuqsQQsm4X25Guseq+80g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)