UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VCJhQUBmBWkBhFX+s9XvIQEjdtRbJqn0otA9GX0Rj3s='
WHERE
key_id = 'df2881b00d814dbec41d2bbef0a0a0aac6d3014f0bf27ac402027457ee87c136'
AND (
token = 'VCJhQUBmBWkBhFX+s9XvIQEjdtRbJqn0otA9GX0Rj3s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)