UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'kIz0a7FxFM5uzPiWYGDxRo+gD1KJeOVm1Yoh+aJgII8='
WHERE
key_id = '9b3607dc3e838a2ddf90ea79887f7b0243a3effea4790f6cf2497b2a74fa098b'
AND (
token = 'kIz0a7FxFM5uzPiWYGDxRo+gD1KJeOVm1Yoh+aJgII8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)