UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ci/cW5Pwm7gujliTc4oOGEgvreyarw2DOunwppWOMfc='
WHERE
key_id = '55b686781b530d4f8168086d5bee372896d2d6e5a0fc2c9a841c964772ecf339'
AND (
token = 'ci/cW5Pwm7gujliTc4oOGEgvreyarw2DOunwppWOMfc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)