UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HQltS9CbUTMx34rAcHSNxzTOLpowzYfH9vv8mgUbQX0='
WHERE
key_id = 'e7ed3341a5382e1404f4eeb09a32f2e3d196cb02e38cc0da50a5dd11b9e9589f'
AND (
token = 'HQltS9CbUTMx34rAcHSNxzTOLpowzYfH9vv8mgUbQX0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)