UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NMlcwU7ExawDIAiaZ+I1pFVaAyYqkZPdFohsKWsGKHY='
WHERE
key_id = '0df0207d55f8bc78d0cec3b811bbdad7399bc14f6665eb54f56a231fe92a0f82'
AND (
token = 'NMlcwU7ExawDIAiaZ+I1pFVaAyYqkZPdFohsKWsGKHY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)