UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MQ6d5snHWpYMw3LASi1qJ5lhgIl8HJE1R2RFcfs6/Ro='
WHERE
key_id = '65107892c1a787df69301fd33ed82a0369d9f2ab776ce47d4f7ce9efeeaa3af2'
AND (
token = 'MQ6d5snHWpYMw3LASi1qJ5lhgIl8HJE1R2RFcfs6/Ro='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)