UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CAFVolbmIrZ+5dHhBbRez2Vzfwqtp2AzLwuu0Pe02aE='
WHERE
key_id = '2f95b401faeccb97807b064286aaa22fd80afbf70a04b2cefa2b309218f12ef7'
AND (
token = 'CAFVolbmIrZ+5dHhBbRez2Vzfwqtp2AzLwuu0Pe02aE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)