UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bcCDFTrxDDs487ZFFB4PB3xExIEJ7u3bi42ZpSum61Y='
WHERE
key_id = '8e06b396191a29bcc371e67413956ad9f0ebb5ea518ae248d25dc905b9ab35cd'
AND (
token = 'bcCDFTrxDDs487ZFFB4PB3xExIEJ7u3bi42ZpSum61Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)