UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd6lb/dAIbPIcMVxvZoi0I6vIKabnIOAWlzfPdKxjcYc='
WHERE
key_id = 'c149b593d4ba13718a2c92d139b84b7d69819df5141793ca64aa4f0c0558eb94'
AND (
token = 'd6lb/dAIbPIcMVxvZoi0I6vIKabnIOAWlzfPdKxjcYc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)