UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hsmED8hWfMLMDbS1Hj5qqUSpas4Nz6CO9FR4p+g4OOg='
WHERE
key_id = '77d87bcbdc8779e7e21884156aa76c464e0024178c3feeeac95c3cbff15a3979'
AND (
token = 'hsmED8hWfMLMDbS1Hj5qqUSpas4Nz6CO9FR4p+g4OOg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)