UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xZD9/V7LTE1To4gMj6BAMtvMacX5Zoh+Vtw50HS2PYY='
WHERE
key_id = '199a31bca0391df0fcec31e1f98308c12b14c2d7e1f7d93fe809a0ba8f4c4842'
AND (
token = 'xZD9/V7LTE1To4gMj6BAMtvMacX5Zoh+Vtw50HS2PYY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)