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