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