UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qrg5o1BCRx9BeyWud70UFLCD9g3kfdSJQ8RjNDtmxWc='
WHERE
key_id = '8e1b5c1c9bdf65f57addfd10a86c26375e7966c5f36efa589059e2c94a3f5830'
AND (
token = 'qrg5o1BCRx9BeyWud70UFLCD9g3kfdSJQ8RjNDtmxWc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)