UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QxJTbCEIlsYWBxItCJ8dD9z7lqdAtN1I2PwjbKxxvdw='
WHERE
key_id = '3e70faee0887ce667a0192b0c1b09a8b46c06bfd42ac7481c42750040480a0e6'
AND (
token = 'QxJTbCEIlsYWBxItCJ8dD9z7lqdAtN1I2PwjbKxxvdw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)