UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x/BEZImTiDj10Ur7aeDq+WYTfUANc8QIQKdrjf+zNGo='
WHERE
key_id = 'dd768b97d8bce8a1f93dc4e93b17e840427787629d0b3621a0714266b70cf7cb'
AND (
token = 'x/BEZImTiDj10Ur7aeDq+WYTfUANc8QIQKdrjf+zNGo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)