UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'aFVwcMCWL/spx9Me26Uea4Jlg9CmP0eB8VC2wh08fVw='
WHERE
key_id = 'd02c1a5226758205344c42ef74d36054ca8a05aed4532c61783f2d8b4a68f0a6'
AND (
token = 'aFVwcMCWL/spx9Me26Uea4Jlg9CmP0eB8VC2wh08fVw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)