UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BCbfPcbnFBMKCMxnSiBz7vkZGo5gFWJG3jUcVA0IjE8='
WHERE
key_id = '678c9bc9ec916f0335d184290eb5b91fa5a2e66e4a75719bc705c08db2164e99'
AND (
token = 'BCbfPcbnFBMKCMxnSiBz7vkZGo5gFWJG3jUcVA0IjE8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)