UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/wgV3+GYiYvsHNvmJFip0SfHPNg8TDyAeWfjp8FPxW8='
WHERE
key_id = 'c8e0f307c53871887b6c19ed831c80c94750b656293e8a0c3d46923f417fb1d9'
AND (
token = '/wgV3+GYiYvsHNvmJFip0SfHPNg8TDyAeWfjp8FPxW8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)